Introduction of Problem Domain and Dataset


This project is about the vaccinations of COVID-19 vaccines in the US. Given that the Delta variant is causing a new surge of COVID-19 cases, it is key that all people get their vaccination as soon as possible. We are eager to know how people of different states react to vaccination. By breaking down the vaccinated population by state, it would be easier to create targeting incentives, promoting vaccination to fight against the more transmissible Delta variant. Our data set is downloaded from the CDC website and contains information including the amount of vaccines distributed to and administered in each state over the course of 228 days, from 12/20/2020 to 08/04/2021.

Summary Information


For the summary, we included the following information:

date, location, total_vaccinations, total_distributed, people_vaccinated, people_fully_vaccinated_per_hundred, total_vaccinations_per_hundred, people_fully_vaccinated, people_vaccinated_per_hundred, distributed_per_hundred, daily_vaccinations_raw, daily_vaccinations, daily_vaccinations_per_million, share_doses_used, DEM, REP, usa_state, usa_state_code, percent_democrat

318812620

Vermont

California

4409114

Aggregate Table


Below is a table that summarizes the number of average daily vaccinations and what day in the week has the most vaccinations in each state.

Location Political Stance Most Vaccination Weekday Daily Average Vaccination Percentage of Daily Vaccinated Population Fully-Vaccinated Population Total Vaccinations
Vermont DEM Sunday 4163.9755 0.6681 422436 875208
Massachusetts DEM Saturday 43987.2500 0.6364 4420802 9177481
Connecticut DEM Friday 21867.1912 0.6155 2264139 4612302
Puerto Rico NA Thursday 19196.8922 0.6010 1920091 3990725
District of Columbia DEM Sunday 4291.7843 0.6010 388214 905336
Rhode Island DEM Friday 6352.7108 0.5985 653856 1335521
Hawaii DEM Friday 8286.7598 0.5892 760225 1723982
Maine DEM Friday 7953.2843 0.5872 860804 1677415
Maryland DEM Wednesday 34824.0980 0.5741 3573644 7250347
New Jersey DEM Saturday 50111.7353 0.5647 5213483 10443839
New Mexico DEM Friday 11885.6029 0.5646 1205059 2502898
Washington DEM Sunday 43396.4363 0.5566 4409114 9048440
New Hampshire DEM Thursday 7591.0588 0.5532 794914 1599189
California DEM Saturday 218876.0490 0.5525 21010034 45467015
Pennsylvania DEM Saturday 70197.8971 0.5482 6743072 14662319
Virginia DEM Friday 46803.6912 0.5440 4674811 9738560
Oregon DEM Sunday 22835.2206 0.5324 2369063 4762995
Delaware DEM Friday 5244.7549 0.5296 515850 1096340
Colorado DEM Sunday 30807.6471 0.5227 3148013 6509188
Illinois DEM Saturday 65641.9314 0.5222 6184160 13737959
Minnesota DEM Saturday 29157.1863 0.5110 3043718 6110306
Wisconsin DEM Saturday 29667.9608 0.5069 3024706 6189517
Florida REP Saturday 108691.1912 0.4953 10567995 22806443
Iowa REP Saturday 14996.1127 0.4734 1572078 3157898
Nebraska REP Thursday 9214.2990 0.4720 961636 1954156
Michigan DEM Saturday 47120.1225 0.4716 4895367 9840190
Arizona DEM Thursday 34336.8922 0.4566 3309350 7146081
Ohio REP Saturday 53081.6716 0.4531 5458126 11140551
Nevada DEM Saturday 14374.6961 0.4512 1378022 2994091
Alaska REP Saturday 3258.2990 0.4498 334266 700531
Kentucky REP Friday 20108.5980 0.4488 2049739 4234268
Kansas REP Saturday 12970.2255 0.4446 1324216 2724194
Texas REP Friday 131320.9314 0.4417 12810625 27700931
South Dakota REP Friday 3955.7745 0.4412 416897 855676
North Carolina REP Wednesday 46974.6029 0.4390 4611928 9794429
Utah REP Saturday 14385.6961 0.4345 1446522 3029907
Indiana REP Saturday 29002.8529 0.4262 2990310 6108426
Missouri REP Saturday 26256.0441 0.4256 2554854 5518017
Montana REP Friday 4584.3627 0.4225 475041 977293
Oklahoma REP Friday 16355.4069 0.4099 1602871 3494346
South Carolina REP Sunday 21401.5098 0.4055 2102925 4446983
North Dakota REP Friday 3070.0245 0.3987 306479 665764
Georgia DEM Friday 43001.1324 0.3971 4106222 8942802
Arkansas REP Saturday 12042.5147 0.3969 1118090 2497552
Tennessee REP Saturday 27224.5588 0.3920 2684149 5805067
West Virginia REP Friday 6792.2892 0.3842 700616 1488957
Louisiana REP Friday 17431.2451 0.3767 1727145 3698745
Wyoming REP Friday 2114.1275 0.3638 212447 447749
Alabama REP Thursday 17490.6863 0.3545 1696031 3646234
Idaho REP Sunday 6593.6373 0.3545 670821 1380947
Mississippi REP Wednesday 10459.2696 0.3526 1035252 2188235
New York State NA Saturday 110350.9118 NA 11165792 23091118
Long Term Care NA Friday 34092.4755 NA NA 7906639
Veterans Health NA Saturday 25556.6127 NA 2737936 5440303
Dept of Defense NA Sunday 21337.8971 NA 1975555 4492370
Indian Health Svc NA Saturday 7014.6373 NA 684170 1499373
Guam NA Friday 978.5441 NA 99024 203414
Bureau of Prisons NA Thursday 916.1176 NA 100269 201551
Virgin Islands NA Wednesday 416.4657 NA 37870 85839
Northern Mariana Islands NA Wednesday 286.1422 NA 29848 62095
Federated States of Micronesia NA Wednesday 274.5637 NA 29544 56435
American Samoa NA Wednesday 247.2304 NA 24042 52559
Marshall Islands NA Sunday 175.8873 NA 17505 36520
Republic of Palau NA Sunday 128.7157 NA 13627 26674

We sorted the table in descending order based on the Percentage of Daily Vaccinated Population, and Vermont tuned out to be the state with the most percentage of population vaccinated every day. This result resonates well with one of the conclusion we drew from the summary: Vermont has the highest fully-vaccinated population ratio among all states.

We were also interested in knowing on what day in the week people are the most willing to go get vaccinated in the week and concluded from that Saturday has the most vaccinations; this is likely because many people work on weekdays and are not able to go get their vaccination on such days. Another thing we found interesting from the table is that the states with higher rates of fully vaccinated population are democratic states.

Leaflet Map


Below is a map that shows the percentage of the population that is fully vaccinated in each state.

We used Leaflet, the most common open source for interactive map charts, to generate the map and facilitate further web-page programming using shiny(). While there are other districts, departments, and entities listed in the data, we only selected the 51 states/districts in the US as we hoped to see the distribution of the fully vaccinated population in each states. Based on the map, we are able to conclude that states on the west coast and the upper east coast are the most vaccinated states, while many of the southern states are the least vaccinated states. This result can be tied back to the aggregated table and illustrate the fact that democratic states tend to have the highest rate of vaccinated population.

Area Graph


Below is a area graph that shows the trend of vaccinations in weeks starting from week 1 in 2021 to week 31 in 2021 (01/04/2012 - 08/04/2021). *Note that week 31 only has data for three days.

We used an area chart for our data set with a great scale of quantitative data, as it is one of the best way for communicating a trend over the course of a specified period.

The area graph shows that the weekly vaccination in the US in 2021 started at around 4 million at the beginning and increased until it peaked in week 15, which is mid-April. However, the number of weekly vaccinations started to decrease afterwards. The reason why this sudden and sharp decline is yet to be discussed and will be included in the final submission.

Bar Chart


Below is a bar chart that shows the percentage of males and females in the US population, the vaccinated population, and the people vaccinated in the last 14 days.

Bar chart is a useful layout to compare the differences between genders in our data set. According the the three bars shown above, while the percentage of females and males in the US are nearly equal, more females are vaccinated than males in the fully-vaccinated population. At this point in time, we can conclude that females are generally more open to vaccination than males in the US.